set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'mov_getGenreListing' AND type = 'P') 
DROP PROCEDURE mov_getGenreListing
GO



-- =============================================
-- Modified:    Sourov Chatterjee
-- Create date: 6/3/2011
-- Description:	This procedure gets director listings

-- =============================================
CREATE PROCEDURE [dbo].[mov_getGenreListing] 	

AS
BEGIN

	SELECT movie_genre_ID, movie_genre 
    FROM Movie_genre
    order by movie_genre
	

END


